PostgreSQL DatabaseΒΆ

  • version: 2.3

  • Compatibility: v 7.5.3

  • Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Database Name (Mandatory), Timout (Mandatory), Enable Time Monitoring (Mandatory), Metric Collector Time (Mandatory)

  • Operation: monitors the port service of PostgreSQL Database.

  • Plugin-Metrics:

Metric

Data Type

Connection Time (MS)

Numeric

Database Name

String

Database Size (Bytes)

Numeric

Database Table

Numeric

Instance Columns:

Table

Metric

Data Type

Table

String

Table Sequential Scans

Numeric

Table Sequential Live Rows Read

Numeric

Table Index Scans

Numeric

Table Index Rows Fetch

Numeric

Table Inserted Rows

Numeric

Table Updated Rows

Numeric

Table Deleted Rows

Numeric

Table Live Rows

Numeric

Table Dead Rows

Numeric

Table Last Auto Vacuum

String

Table Hot Rows Updated

Numeric

Table Last Auto Analyze

String

Table Auto Vacuum

Numeric

Table Auto Analyze

Numeric

Table Rows

Numeric

Table Size (KB)

Numeric

Table Index Size (Bytes)

Numeric

Table Sequential Scans/sec

Numeric

Table Sequential Live Rows Read/sec

Numeric

Table Index Scans/sec

Numeric

Table Index Rows Fetch/sec

Numeric

Table Inserted Rows/sec

Numeric

Table Updated Rows/sec

Numeric

Table Deleted Rows/sec

Numeric